COVID-19 in Italy. Visuals

(alternatively, see results and code together here)

 

Data source: this GitHubi page

Authors and sources mentioned: Editore/Autore del dataset: Dipartimento della Protezione Civile. Categoria ISO 19115: Salute. Dati forniti dal Ministero della Salute.

Regional data files (Dati per Regione):
  • Struttura file giornaliero: dpc-covid19-ita-regioni-yyyymmdd.csv (dpc-covid19-ita-regioni-20200224.csv)
  • File complessivo: dpc-covid19-ita-regioni.csv
  • File ultimi dati (latest): dpc-covid19-ita-regioni-latest.csv

 

Out[4]:

Currently data as of date: 2020-11-15T17:00:00

 

What's in the original dataframe?

Out[5]:

All column names: ['data', 'stato', 'codice_regione', 'denominazione_regione', 'lat', 'long', 'ricoverati_con_sintomi', 'terapia_intensiva', 'totale_ospedalizzati', 'isolamento_domiciliare', 'totale_positivi', 'variazione_totale_positivi', 'nuovi_positivi', 'dimessi_guariti', 'deceduti', 'casi_da_sospetto_diagnostico', 'casi_da_screening', 'totale_casi', 'tamponi', 'casi_testati', 'note']

Out[6]:
data stato codice_regione denominazione_regione lat long ricoverati_con_sintomi terapia_intensiva totale_ospedalizzati isolamento_domiciliare ... variazione_totale_positivi nuovi_positivi dimessi_guariti deceduti casi_da_sospetto_diagnostico casi_da_screening totale_casi tamponi casi_testati note
5581 2020-11-15T17:00:00 ITA 19 Sicilia 38.115697 13.362357 1476 217 1693 27114 ... 1001 1422 11829 896 25806.0 15726.0 41532 816609 565253.0 NaN
5582 2020-11-15T17:00:00 ITA 9 Toscana 43.769231 11.255889 1734 274 2008 50300 ... 1247 2653 25216 1879 63548.0 15855.0 79403 1331924 856660.0 NaN
5583 2020-11-15T17:00:00 ITA 10 Umbria 43.106758 12.388247 366 71 437 10658 ... 319 657 7528 253 5315.0 13561.0 18876 360719 203439.0 Si fa presente come nel computo dei ricoverati...
5584 2020-11-15T17:00:00 ITA 2 Valle d'Aosta 45.737503 7.320149 148 12 160 2135 ... -4 143 2703 248 4641.0 605.0 5246 50230 29683.0 NaN
5585 2020-11-15T17:00:00 ITA 5 Veneto 45.434905 12.338452 1934 241 2175 59331 ... 1801 2792 36525 2845 27442.0 73434.0 100876 2562531 989643.0 Tamponi antigenici 588.190

5 rows × 21 columns

 

Variable names to English and their explanation

  • HospWithSymptoms : Currently hospitalized patients with symptoms
  • IC : Intensive care
  • HospTotal: Total number of currently hospitalized patients
  • AtHome : Currently at home confinement
  • CurrentlyPositive : Total amount of current positive cases (Hospitalised patients + Home confinement)
  • NewPositives : New amount of positive cases (Actual total amount of current positive cases - total amount of current positive cases of the previous day)
  • TotalCases : Total amount of positive cases
  • NoOfTests : Tests performed
Out[7]:
Date Region Lat Long HospWithSymptoms IC HospTotal AtHome CurrentlyPositive VariationOfPositives NewPositives Recovered Deaths Diagnostico Screening TotalCases NoOfTests casi_testati note Pop
Date
2020-11-11 2020-11-11 Veneto 45.434905 12.338452 1669 208 1877 50358 52235 1985 3082 32413 2689 26526.0 60811.0 87337 2494150 965761.0 tamponi antigenici 492.456 4905854
2020-11-12 2020-11-12 Veneto 45.434905 12.338452 1763 213 1976 52779 54755 2520 3564 33419 2727 26696.0 64205.0 90901 2511361 971907.0 Tamponi antigenici 519.458 4905854
2020-11-13 2020-11-13 Veneto 45.434905 12.338452 1831 219 2050 55238 57288 2533 3605 34454 2764 26878.0 67628.0 94506 2529005 978328.0 Tamponi antigenici 543.099 4905854
2020-11-14 2020-11-14 Veneto 45.434905 12.338452 1869 228 2097 57608 59705 2417 3578 35563 2816 27166.0 70918.0 98084 2547409 984607.0 Tamponi antigenici 577.984 4905854
2020-11-15 2020-11-15 Veneto 45.434905 12.338452 1934 241 2175 59331 61506 1801 2792 36525 2845 27442.0 73434.0 100876 2562531 989643.0 Tamponi antigenici 588.190 4905854

 

daily numbers & moving averages (MA)

(double click and click on legend to select one or multiple regions in the graph)

 

All regions together